Order by alphabet function

To apply any of function like:

§          Order by alphabet                                 not MDX function, implementation of MDX Order funciton

 

for element function you need to

§          … select with mouse desired element (one row) and right-click with mouse

§          … select Element functions menu

for hierarchy function you need to

§          … right-click over member that belongs to desired hierarchy

§          … select Hierarchy functions menu

for axis function you need to

§          … right-click inside row or column area

§          … select Axis functions menu

then select

§          … any Order by alphabet function from submenu

 

 

In our case let us try to order:

 

hierarchy hCountry

 

Dialog will appear:

 

 

§          select appropriate option

o         BDESC

o         DESC

o         BASC

o         ASC

§          select OK

 

After confirmation result is: